Example: Transpose

A new dataset will be created, summarizing the information required from the dataset. This new pivot dataset will present the requested aggregations on the selected fields. If selected and configured, the aggregations can also be presented on groups within the fields, instead of the field as a whole. The newly created fields in the pivot dataset can then be prioritized by using the sorting option.

Initial dataset:

Configuration:

We are looking for an answer to the question: "During which shift on which day of the week do I get the greatest production?" The pivot table we configure needs to be able to present a summary of production per shift for each day of the week so we can determine the shift of highest production.

Grouped by: Shift

Pivot field: Day

Class: 5 classes will be created, one for each day of the week

- Class: Monday
- Field: Production
- Aggregation: Sum
- Name: Sum_Monday_Production (This will be the name of the new fields created within the pivot dataset.

- Class: Tues
- Field: Prod
- Aggregation: Sum
- Name: Sum_Tues_Prod

- Class: Wed
- Field: Prod
- Aggregation: Sum
- Name: Sum_Wed_Prod

- Class: Thurs
- Field: Prod
- Aggregation: Sum
- Name: Sum_Thurs_Prod

- Class: Fri
- Field: Prod
- Aggregation: Sum
- Name: Sum_Fri_Prod
- Ordered by: Shift; Sum_Monday_Production; Sum_Tues_Prod; Sum_Wed_Prod; Sum_Thurs_Prod; Sum_Fri_Prod

Resulting dataset:

From this resulting pivot dataset, we can easily see that production was greatest during shift 2 on Wednesdays.